package com.gridmobi.xrtb.domain.adn;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class ConfirmMonthlyExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    public ConfirmMonthlyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andClientidIsNull() {
            addCriterion("clientid is null");
            return (Criteria) this;
        }

        public Criteria andClientidIsNotNull() {
            addCriterion("clientid is not null");
            return (Criteria) this;
        }

        public Criteria andClientidEqualTo(Integer value) {
            addCriterion("clientid =", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidNotEqualTo(Integer value) {
            addCriterion("clientid <>", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidGreaterThan(Integer value) {
            addCriterion("clientid >", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidGreaterThanOrEqualTo(Integer value) {
            addCriterion("clientid >=", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidLessThan(Integer value) {
            addCriterion("clientid <", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidLessThanOrEqualTo(Integer value) {
            addCriterion("clientid <=", value, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidIn(List<Integer> values) {
            addCriterion("clientid in", values, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidNotIn(List<Integer> values) {
            addCriterion("clientid not in", values, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidBetween(Integer value1, Integer value2) {
            addCriterion("clientid between", value1, value2, "clientid");
            return (Criteria) this;
        }

        public Criteria andClientidNotBetween(Integer value1, Integer value2) {
            addCriterion("clientid not between", value1, value2, "clientid");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueIsNull() {
            addCriterion("deductrevenue is null");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueIsNotNull() {
            addCriterion("deductrevenue is not null");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueEqualTo(Integer value) {
            addCriterion("deductrevenue =", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueNotEqualTo(Integer value) {
            addCriterion("deductrevenue <>", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueGreaterThan(Integer value) {
            addCriterion("deductrevenue >", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueGreaterThanOrEqualTo(Integer value) {
            addCriterion("deductrevenue >=", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueLessThan(Integer value) {
            addCriterion("deductrevenue <", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueLessThanOrEqualTo(Integer value) {
            addCriterion("deductrevenue <=", value, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueIn(List<Integer> values) {
            addCriterion("deductrevenue in", values, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueNotIn(List<Integer> values) {
            addCriterion("deductrevenue not in", values, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueBetween(Integer value1, Integer value2) {
            addCriterion("deductrevenue between", value1, value2, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andDeductrevenueNotBetween(Integer value1, Integer value2) {
            addCriterion("deductrevenue not between", value1, value2, "deductrevenue");
            return (Criteria) this;
        }

        public Criteria andClientnameIsNull() {
            addCriterion("clientname is null");
            return (Criteria) this;
        }

        public Criteria andClientnameIsNotNull() {
            addCriterion("clientname is not null");
            return (Criteria) this;
        }

        public Criteria andClientnameEqualTo(String value) {
            addCriterion("clientname =", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotEqualTo(String value) {
            addCriterion("clientname <>", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameGreaterThan(String value) {
            addCriterion("clientname >", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameGreaterThanOrEqualTo(String value) {
            addCriterion("clientname >=", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLessThan(String value) {
            addCriterion("clientname <", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLessThanOrEqualTo(String value) {
            addCriterion("clientname <=", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLike(String value) {
            addCriterion("clientname like", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotLike(String value) {
            addCriterion("clientname not like", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameIn(List<String> values) {
            addCriterion("clientname in", values, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotIn(List<String> values) {
            addCriterion("clientname not in", values, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameBetween(String value1, String value2) {
            addCriterion("clientname between", value1, value2, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotBetween(String value1, String value2) {
            addCriterion("clientname not between", value1, value2, "clientname");
            return (Criteria) this;
        }

        public Criteria andMonthlyIsNull() {
            addCriterion("monthly is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyIsNotNull() {
            addCriterion("monthly is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyEqualTo(String value) {
            addCriterion("monthly =", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyNotEqualTo(String value) {
            addCriterion("monthly <>", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyGreaterThan(String value) {
            addCriterion("monthly >", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyGreaterThanOrEqualTo(String value) {
            addCriterion("monthly >=", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyLessThan(String value) {
            addCriterion("monthly <", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyLessThanOrEqualTo(String value) {
            addCriterion("monthly <=", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyLike(String value) {
            addCriterion("monthly like", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyNotLike(String value) {
            addCriterion("monthly not like", value, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyIn(List<String> values) {
            addCriterion("monthly in", values, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyNotIn(List<String> values) {
            addCriterion("monthly not in", values, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyBetween(String value1, String value2) {
            addCriterion("monthly between", value1, value2, "monthly");
            return (Criteria) this;
        }

        public Criteria andMonthlyNotBetween(String value1, String value2) {
            addCriterion("monthly not between", value1, value2, "monthly");
            return (Criteria) this;
        }

        public Criteria andYyearIsNull() {
            addCriterion("yyear is null");
            return (Criteria) this;
        }

        public Criteria andYyearIsNotNull() {
            addCriterion("yyear is not null");
            return (Criteria) this;
        }

        public Criteria andYyearEqualTo(Integer value) {
            addCriterion("yyear =", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearNotEqualTo(Integer value) {
            addCriterion("yyear <>", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearGreaterThan(Integer value) {
            addCriterion("yyear >", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearGreaterThanOrEqualTo(Integer value) {
            addCriterion("yyear >=", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearLessThan(Integer value) {
            addCriterion("yyear <", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearLessThanOrEqualTo(Integer value) {
            addCriterion("yyear <=", value, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearIn(List<Integer> values) {
            addCriterion("yyear in", values, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearNotIn(List<Integer> values) {
            addCriterion("yyear not in", values, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearBetween(Integer value1, Integer value2) {
            addCriterion("yyear between", value1, value2, "yyear");
            return (Criteria) this;
        }

        public Criteria andYyearNotBetween(Integer value1, Integer value2) {
            addCriterion("yyear not between", value1, value2, "yyear");
            return (Criteria) this;
        }

        public Criteria andRevenueIsNull() {
            addCriterion("revenue is null");
            return (Criteria) this;
        }

        public Criteria andRevenueIsNotNull() {
            addCriterion("revenue is not null");
            return (Criteria) this;
        }

        public Criteria andRevenueEqualTo(Float value) {
            addCriterion("revenue =", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueNotEqualTo(Float value) {
            addCriterion("revenue <>", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueGreaterThan(Float value) {
            addCriterion("revenue >", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueGreaterThanOrEqualTo(Float value) {
            addCriterion("revenue >=", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueLessThan(Float value) {
            addCriterion("revenue <", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueLessThanOrEqualTo(Float value) {
            addCriterion("revenue <=", value, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueIn(List<Float> values) {
            addCriterion("revenue in", values, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueNotIn(List<Float> values) {
            addCriterion("revenue not in", values, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueBetween(Float value1, Float value2) {
            addCriterion("revenue between", value1, value2, "revenue");
            return (Criteria) this;
        }

        public Criteria andRevenueNotBetween(Float value1, Float value2) {
            addCriterion("revenue not between", value1, value2, "revenue");
            return (Criteria) this;
        }

        public Criteria andConversionsIsNull() {
            addCriterion("conversions is null");
            return (Criteria) this;
        }

        public Criteria andConversionsIsNotNull() {
            addCriterion("conversions is not null");
            return (Criteria) this;
        }

        public Criteria andConversionsEqualTo(Integer value) {
            addCriterion("conversions =", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsNotEqualTo(Integer value) {
            addCriterion("conversions <>", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsGreaterThan(Integer value) {
            addCriterion("conversions >", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsGreaterThanOrEqualTo(Integer value) {
            addCriterion("conversions >=", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsLessThan(Integer value) {
            addCriterion("conversions <", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsLessThanOrEqualTo(Integer value) {
            addCriterion("conversions <=", value, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsIn(List<Integer> values) {
            addCriterion("conversions in", values, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsNotIn(List<Integer> values) {
            addCriterion("conversions not in", values, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsBetween(Integer value1, Integer value2) {
            addCriterion("conversions between", value1, value2, "conversions");
            return (Criteria) this;
        }

        public Criteria andConversionsNotBetween(Integer value1, Integer value2) {
            addCriterion("conversions not between", value1, value2, "conversions");
            return (Criteria) this;
        }

        public Criteria andCrevenueIsNull() {
            addCriterion("crevenue is null");
            return (Criteria) this;
        }

        public Criteria andCrevenueIsNotNull() {
            addCriterion("crevenue is not null");
            return (Criteria) this;
        }

        public Criteria andCrevenueEqualTo(Float value) {
            addCriterion("crevenue =", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueNotEqualTo(Float value) {
            addCriterion("crevenue <>", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueGreaterThan(Float value) {
            addCriterion("crevenue >", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueGreaterThanOrEqualTo(Float value) {
            addCriterion("crevenue >=", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueLessThan(Float value) {
            addCriterion("crevenue <", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueLessThanOrEqualTo(Float value) {
            addCriterion("crevenue <=", value, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueIn(List<Float> values) {
            addCriterion("crevenue in", values, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueNotIn(List<Float> values) {
            addCriterion("crevenue not in", values, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueBetween(Float value1, Float value2) {
            addCriterion("crevenue between", value1, value2, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCrevenueNotBetween(Float value1, Float value2) {
            addCriterion("crevenue not between", value1, value2, "crevenue");
            return (Criteria) this;
        }

        public Criteria andCconversionsIsNull() {
            addCriterion("cconversions is null");
            return (Criteria) this;
        }

        public Criteria andCconversionsIsNotNull() {
            addCriterion("cconversions is not null");
            return (Criteria) this;
        }

        public Criteria andCconversionsEqualTo(Integer value) {
            addCriterion("cconversions =", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsNotEqualTo(Integer value) {
            addCriterion("cconversions <>", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsGreaterThan(Integer value) {
            addCriterion("cconversions >", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsGreaterThanOrEqualTo(Integer value) {
            addCriterion("cconversions >=", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsLessThan(Integer value) {
            addCriterion("cconversions <", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsLessThanOrEqualTo(Integer value) {
            addCriterion("cconversions <=", value, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsIn(List<Integer> values) {
            addCriterion("cconversions in", values, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsNotIn(List<Integer> values) {
            addCriterion("cconversions not in", values, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsBetween(Integer value1, Integer value2) {
            addCriterion("cconversions between", value1, value2, "cconversions");
            return (Criteria) this;
        }

        public Criteria andCconversionsNotBetween(Integer value1, Integer value2) {
            addCriterion("cconversions not between", value1, value2, "cconversions");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueIsNull() {
            addCriterion("invoicerevenue is null");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueIsNotNull() {
            addCriterion("invoicerevenue is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueEqualTo(Float value) {
            addCriterion("invoicerevenue =", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueNotEqualTo(Float value) {
            addCriterion("invoicerevenue <>", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueGreaterThan(Float value) {
            addCriterion("invoicerevenue >", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueGreaterThanOrEqualTo(Float value) {
            addCriterion("invoicerevenue >=", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueLessThan(Float value) {
            addCriterion("invoicerevenue <", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueLessThanOrEqualTo(Float value) {
            addCriterion("invoicerevenue <=", value, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueIn(List<Float> values) {
            addCriterion("invoicerevenue in", values, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueNotIn(List<Float> values) {
            addCriterion("invoicerevenue not in", values, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueBetween(Float value1, Float value2) {
            addCriterion("invoicerevenue between", value1, value2, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicerevenueNotBetween(Float value1, Float value2) {
            addCriterion("invoicerevenue not between", value1, value2, "invoicerevenue");
            return (Criteria) this;
        }

        public Criteria andInvoicepathIsNull() {
            addCriterion("invoicepath is null");
            return (Criteria) this;
        }

        public Criteria andInvoicepathIsNotNull() {
            addCriterion("invoicepath is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicepathEqualTo(Integer value) {
            addCriterion("invoicepath =", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathNotEqualTo(Integer value) {
            addCriterion("invoicepath <>", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathGreaterThan(Integer value) {
            addCriterion("invoicepath >", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoicepath >=", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathLessThan(Integer value) {
            addCriterion("invoicepath <", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathLessThanOrEqualTo(Integer value) {
            addCriterion("invoicepath <=", value, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathIn(List<Integer> values) {
            addCriterion("invoicepath in", values, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathNotIn(List<Integer> values) {
            addCriterion("invoicepath not in", values, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathBetween(Integer value1, Integer value2) {
            addCriterion("invoicepath between", value1, value2, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicepathNotBetween(Integer value1, Integer value2) {
            addCriterion("invoicepath not between", value1, value2, "invoicepath");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameIsNull() {
            addCriterion("invoicefilename is null");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameIsNotNull() {
            addCriterion("invoicefilename is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameEqualTo(Integer value) {
            addCriterion("invoicefilename =", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameNotEqualTo(Integer value) {
            addCriterion("invoicefilename <>", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameGreaterThan(Integer value) {
            addCriterion("invoicefilename >", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoicefilename >=", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameLessThan(Integer value) {
            addCriterion("invoicefilename <", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameLessThanOrEqualTo(Integer value) {
            addCriterion("invoicefilename <=", value, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameIn(List<Integer> values) {
            addCriterion("invoicefilename in", values, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameNotIn(List<Integer> values) {
            addCriterion("invoicefilename not in", values, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameBetween(Integer value1, Integer value2) {
            addCriterion("invoicefilename between", value1, value2, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicefilenameNotBetween(Integer value1, Integer value2) {
            addCriterion("invoicefilename not between", value1, value2, "invoicefilename");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusIsNull() {
            addCriterion("invoicestatus is null");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusIsNotNull() {
            addCriterion("invoicestatus is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusEqualTo(Integer value) {
            addCriterion("invoicestatus =", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusNotEqualTo(Integer value) {
            addCriterion("invoicestatus <>", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusGreaterThan(Integer value) {
            addCriterion("invoicestatus >", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoicestatus >=", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusLessThan(Integer value) {
            addCriterion("invoicestatus <", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusLessThanOrEqualTo(Integer value) {
            addCriterion("invoicestatus <=", value, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusIn(List<Integer> values) {
            addCriterion("invoicestatus in", values, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusNotIn(List<Integer> values) {
            addCriterion("invoicestatus not in", values, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusBetween(Integer value1, Integer value2) {
            addCriterion("invoicestatus between", value1, value2, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andInvoicestatusNotBetween(Integer value1, Integer value2) {
            addCriterion("invoicestatus not between", value1, value2, "invoicestatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusIsNull() {
            addCriterion("paidstatus is null");
            return (Criteria) this;
        }

        public Criteria andPaidstatusIsNotNull() {
            addCriterion("paidstatus is not null");
            return (Criteria) this;
        }

        public Criteria andPaidstatusEqualTo(Integer value) {
            addCriterion("paidstatus =", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusNotEqualTo(Integer value) {
            addCriterion("paidstatus <>", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusGreaterThan(Integer value) {
            addCriterion("paidstatus >", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("paidstatus >=", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusLessThan(Integer value) {
            addCriterion("paidstatus <", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusLessThanOrEqualTo(Integer value) {
            addCriterion("paidstatus <=", value, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusIn(List<Integer> values) {
            addCriterion("paidstatus in", values, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusNotIn(List<Integer> values) {
            addCriterion("paidstatus not in", values, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusBetween(Integer value1, Integer value2) {
            addCriterion("paidstatus between", value1, value2, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andPaidstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("paidstatus not between", value1, value2, "paidstatus");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNull() {
            addCriterion("clienttype is null");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNotNull() {
            addCriterion("clienttype is not null");
            return (Criteria) this;
        }

        public Criteria andClienttypeEqualTo(Integer value) {
            addCriterion("clienttype =", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotEqualTo(Integer value) {
            addCriterion("clienttype <>", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThan(Integer value) {
            addCriterion("clienttype >", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("clienttype >=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThan(Integer value) {
            addCriterion("clienttype <", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThanOrEqualTo(Integer value) {
            addCriterion("clienttype <=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeIn(List<Integer> values) {
            addCriterion("clienttype in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotIn(List<Integer> values) {
            addCriterion("clienttype not in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeBetween(Integer value1, Integer value2) {
            addCriterion("clienttype between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotBetween(Integer value1, Integer value2) {
            addCriterion("clienttype not between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkIsNull() {
            addCriterion("invoiceremark is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkIsNotNull() {
            addCriterion("invoiceremark is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkEqualTo(String value) {
            addCriterion("invoiceremark =", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkNotEqualTo(String value) {
            addCriterion("invoiceremark <>", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkGreaterThan(String value) {
            addCriterion("invoiceremark >", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkGreaterThanOrEqualTo(String value) {
            addCriterion("invoiceremark >=", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkLessThan(String value) {
            addCriterion("invoiceremark <", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkLessThanOrEqualTo(String value) {
            addCriterion("invoiceremark <=", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkLike(String value) {
            addCriterion("invoiceremark like", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkNotLike(String value) {
            addCriterion("invoiceremark not like", value, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkIn(List<String> values) {
            addCriterion("invoiceremark in", values, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkNotIn(List<String> values) {
            addCriterion("invoiceremark not in", values, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkBetween(String value1, String value2) {
            addCriterion("invoiceremark between", value1, value2, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andInvoiceremarkNotBetween(String value1, String value2) {
            addCriterion("invoiceremark not between", value1, value2, "invoiceremark");
            return (Criteria) this;
        }

        public Criteria andDeleteflgIsNull() {
            addCriterion("deleteflg is null");
            return (Criteria) this;
        }

        public Criteria andDeleteflgIsNotNull() {
            addCriterion("deleteflg is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteflgEqualTo(Integer value) {
            addCriterion("deleteflg =", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgNotEqualTo(Integer value) {
            addCriterion("deleteflg <>", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgGreaterThan(Integer value) {
            addCriterion("deleteflg >", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleteflg >=", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgLessThan(Integer value) {
            addCriterion("deleteflg <", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgLessThanOrEqualTo(Integer value) {
            addCriterion("deleteflg <=", value, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgIn(List<Integer> values) {
            addCriterion("deleteflg in", values, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgNotIn(List<Integer> values) {
            addCriterion("deleteflg not in", values, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgBetween(Integer value1, Integer value2) {
            addCriterion("deleteflg between", value1, value2, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andDeleteflgNotBetween(Integer value1, Integer value2) {
            addCriterion("deleteflg not between", value1, value2, "deleteflg");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andInvoicenoIsNull() {
            addCriterion("invoiceno is null");
            return (Criteria) this;
        }

        public Criteria andInvoicenoIsNotNull() {
            addCriterion("invoiceno is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicenoEqualTo(String value) {
            addCriterion("invoiceno =", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoNotEqualTo(String value) {
            addCriterion("invoiceno <>", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoGreaterThan(String value) {
            addCriterion("invoiceno >", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoGreaterThanOrEqualTo(String value) {
            addCriterion("invoiceno >=", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoLessThan(String value) {
            addCriterion("invoiceno <", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoLessThanOrEqualTo(String value) {
            addCriterion("invoiceno <=", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoLike(String value) {
            addCriterion("invoiceno like", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoNotLike(String value) {
            addCriterion("invoiceno not like", value, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoIn(List<String> values) {
            addCriterion("invoiceno in", values, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoNotIn(List<String> values) {
            addCriterion("invoiceno not in", values, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoBetween(String value1, String value2) {
            addCriterion("invoiceno between", value1, value2, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andInvoicenoNotBetween(String value1, String value2) {
            addCriterion("invoiceno not between", value1, value2, "invoiceno");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeIsNull() {
            addCriterion("revenuetype is null");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeIsNotNull() {
            addCriterion("revenuetype is not null");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeEqualTo(String value) {
            addCriterion("revenuetype =", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeNotEqualTo(String value) {
            addCriterion("revenuetype <>", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeGreaterThan(String value) {
            addCriterion("revenuetype >", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeGreaterThanOrEqualTo(String value) {
            addCriterion("revenuetype >=", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeLessThan(String value) {
            addCriterion("revenuetype <", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeLessThanOrEqualTo(String value) {
            addCriterion("revenuetype <=", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeLike(String value) {
            addCriterion("revenuetype like", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeNotLike(String value) {
            addCriterion("revenuetype not like", value, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeIn(List<String> values) {
            addCriterion("revenuetype in", values, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeNotIn(List<String> values) {
            addCriterion("revenuetype not in", values, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeBetween(String value1, String value2) {
            addCriterion("revenuetype between", value1, value2, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andRevenuetypeNotBetween(String value1, String value2) {
            addCriterion("revenuetype not between", value1, value2, "revenuetype");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andSubnoIsNull() {
            addCriterion("subno is null");
            return (Criteria) this;
        }

        public Criteria andSubnoIsNotNull() {
            addCriterion("subno is not null");
            return (Criteria) this;
        }

        public Criteria andSubnoEqualTo(String value) {
            addCriterion("subno =", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoNotEqualTo(String value) {
            addCriterion("subno <>", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoGreaterThan(String value) {
            addCriterion("subno >", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoGreaterThanOrEqualTo(String value) {
            addCriterion("subno >=", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoLessThan(String value) {
            addCriterion("subno <", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoLessThanOrEqualTo(String value) {
            addCriterion("subno <=", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoLike(String value) {
            addCriterion("subno like", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoNotLike(String value) {
            addCriterion("subno not like", value, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoIn(List<String> values) {
            addCriterion("subno in", values, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoNotIn(List<String> values) {
            addCriterion("subno not in", values, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoBetween(String value1, String value2) {
            addCriterion("subno between", value1, value2, "subno");
            return (Criteria) this;
        }

        public Criteria andSubnoNotBetween(String value1, String value2) {
            addCriterion("subno not between", value1, value2, "subno");
            return (Criteria) this;
        }

        public Criteria andInvoicedateIsNull() {
            addCriterion("invoicedate is null");
            return (Criteria) this;
        }

        public Criteria andInvoicedateIsNotNull() {
            addCriterion("invoicedate is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicedateEqualTo(Date value) {
            addCriterionForJDBCDate("invoicedate =", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateNotEqualTo(Date value) {
            addCriterionForJDBCDate("invoicedate <>", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateGreaterThan(Date value) {
            addCriterionForJDBCDate("invoicedate >", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("invoicedate >=", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateLessThan(Date value) {
            addCriterionForJDBCDate("invoicedate <", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("invoicedate <=", value, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateIn(List<Date> values) {
            addCriterionForJDBCDate("invoicedate in", values, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateNotIn(List<Date> values) {
            addCriterionForJDBCDate("invoicedate not in", values, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("invoicedate between", value1, value2, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andInvoicedateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("invoicedate not between", value1, value2, "invoicedate");
            return (Criteria) this;
        }

        public Criteria andPaiddateIsNull() {
            addCriterion("paiddate is null");
            return (Criteria) this;
        }

        public Criteria andPaiddateIsNotNull() {
            addCriterion("paiddate is not null");
            return (Criteria) this;
        }

        public Criteria andPaiddateEqualTo(Date value) {
            addCriterionForJDBCDate("paiddate =", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotEqualTo(Date value) {
            addCriterionForJDBCDate("paiddate <>", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateGreaterThan(Date value) {
            addCriterionForJDBCDate("paiddate >", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("paiddate >=", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateLessThan(Date value) {
            addCriterionForJDBCDate("paiddate <", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("paiddate <=", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateIn(List<Date> values) {
            addCriterionForJDBCDate("paiddate in", values, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotIn(List<Date> values) {
            addCriterionForJDBCDate("paiddate not in", values, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("paiddate between", value1, value2, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("paiddate not between", value1, value2, "paiddate");
            return (Criteria) this;
        }

        public Criteria andActualrevenueIsNull() {
            addCriterion("actualrevenue is null");
            return (Criteria) this;
        }

        public Criteria andActualrevenueIsNotNull() {
            addCriterion("actualrevenue is not null");
            return (Criteria) this;
        }

        public Criteria andActualrevenueEqualTo(Float value) {
            addCriterion("actualrevenue =", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueNotEqualTo(Float value) {
            addCriterion("actualrevenue <>", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueGreaterThan(Float value) {
            addCriterion("actualrevenue >", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueGreaterThanOrEqualTo(Float value) {
            addCriterion("actualrevenue >=", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueLessThan(Float value) {
            addCriterion("actualrevenue <", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueLessThanOrEqualTo(Float value) {
            addCriterion("actualrevenue <=", value, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueIn(List<Float> values) {
            addCriterion("actualrevenue in", values, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueNotIn(List<Float> values) {
            addCriterion("actualrevenue not in", values, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueBetween(Float value1, Float value2) {
            addCriterion("actualrevenue between", value1, value2, "actualrevenue");
            return (Criteria) this;
        }

        public Criteria andActualrevenueNotBetween(Float value1, Float value2) {
            addCriterion("actualrevenue not between", value1, value2, "actualrevenue");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}